import openpyxl
from PIL import Image
myBook=openpyxl.load_workbook('新书订购表.xlsx')
mySheet=myBook.active

myImage1=openpyxl.drawing.image.Image('images/myImage1.jpg')
mySheet.add_image(myImage1,'A5')
myImage2=Image.open('images/myImage2.jpg')
myImage2.transpose(Image.Transpose.FLIP_TOP_BOTTOM).save('temp/myIamge2.jpg')
myNewImage2=openpyxl.drawing.image.Image('temp/myImage2.jpg')
mySheet.add_image(myNewImage2,'B5')
myBook.save('结果表-新书订购表.xlsx')
